﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="infostatisticlist.aspx.cs" MasterPageFile="~/Site.master" Inherits="codelist" %>

    <asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">

    <div style="width: 571px; " class="liststly">
        <asp:Label ID="Label1" runat="server" Text="Label">总人数：</asp:Label><asp:Label ID="la_count"
            runat="server" Text="0"><%= Getcount() %> 人</asp:Label>
    <asp:Label runat=server BackColor="Aqua" Font-Bold="True" Height="25px" 
            style="margin-top: 0px; text-align:center" Width="570px">信息统计</asp:Label>

    <asp:GridView ID="gv_infostatistic" runat="server" AutoGenerateColumns="False" CellPadding="4"

                        ForeColor="#333333" 
            DataSourceID="SqlDataSource1"  ShowFooter ="True" GridLines="None" Width="572px" 
            >

                        <EditRowStyle BackColor="#2461BF" />

                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <AlternatingRowStyle BackColor="White" />

                        <Columns>

                            

                            <asp:BoundField DataField="cName" HeaderText="文化程度" SortExpression="cName">
                            <ItemStyle HorizontalAlign="Center" Width="200px"/>
                            </asp:BoundField>
                            <asp:BoundField DataField="Number" HeaderText="人数" 
                                SortExpression="Number" ReadOnly="True">
                            <ItemStyle HorizontalAlign="Center"  Width="200px"/>
                            </asp:BoundField>

                        </Columns>

                        <RowStyle BackColor="#EFF3FB" />

                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <SortedAscendingCellStyle BackColor="#F5F7FB" />
                        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                        <SortedDescendingCellStyle BackColor="#E9EBEF" />
                        <SortedDescendingHeaderStyle BackColor="#4870BE" />

                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DevMgmntConnectionString %>" 
            SelectCommand="SELECT b.sCultureName cName,COUNT(*)  Number FROM [t_record] a left join t_culture b on a.iCulture_ID = b.iCulture_ID group by (b.sCultureName)" >
                        
        </asp:SqlDataSource>
       
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"

                        ForeColor="#333333" 
            DataSourceID="SqlDataSource2"  ShowFooter ="True" GridLines="None" Width="572px"
            >

                        <Columns>
                            <asp:BoundField DataField="dName" HeaderText="部门" SortExpression="dName">
                            <ItemStyle HorizontalAlign="Center"  Width="200px"/>
                            </asp:BoundField>
                            <asp:BoundField DataField="Number" HeaderText="人数" ReadOnly="True" 
                                SortExpression="Number">
                            <ItemStyle HorizontalAlign="Center"  Width="200px"/>
                            </asp:BoundField>
                        </Columns>

                        <EditRowStyle BackColor="#2461BF" />

                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <AlternatingRowStyle BackColor="White" />

                        <RowStyle BackColor="#EFF3FB" />

                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <SortedAscendingCellStyle BackColor="#F5F7FB" />
                        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                        <SortedDescendingCellStyle BackColor="#E9EBEF" />
                        <SortedDescendingHeaderStyle BackColor="#4870BE" />

                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DevMgmntConnectionString %>" 
            SelectCommand="SELECT b.sDepartmentName dName,COUNT(*)  Number FROM [t_record] a left join t_department b on a.iDepartment_ID = b.iDepartment_ID group by (b.sDepartmentName)">
        </asp:SqlDataSource>
                   

        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4"

                        ForeColor="#333333" 
            DataSourceID="SqlDataSource3"  ShowFooter ="True" GridLines="None" Width="572px"
            >

                        <EditRowStyle BackColor="#2461BF" />

                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <AlternatingRowStyle BackColor="White" />

                        <Columns>

                            

                            <asp:BoundField DataField="pName" HeaderText="职位" SortExpression="pName">
                            <ItemStyle HorizontalAlign="Center"  Width="200px"/>
                            </asp:BoundField>
                            <asp:BoundField DataField="Number" HeaderText="人数" 
                                SortExpression="Number" ReadOnly="True">
                            <ItemStyle HorizontalAlign="Center"  Width="200px" />
                            </asp:BoundField>

                        </Columns>

                        <RowStyle BackColor="#EFF3FB" />

                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <SortedAscendingCellStyle BackColor="#F5F7FB" />
                        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                        <SortedDescendingCellStyle BackColor="#E9EBEF" />
                        <SortedDescendingHeaderStyle BackColor="#4870BE" />

                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DevMgmntConnectionString %>" 
            
            SelectCommand="SELECT b.sProfessionaName pName,COUNT(*)  Number FROM [t_record] a left join t_professiona b on a.iProfessiona_ID = b.iProfessiona_ID group by (b.sProfessionaName)">
        </asp:SqlDataSource>
        
                   
        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" CellPadding="4"

                        ForeColor="#333333" 
            DataSourceID="SqlDataSource4"  ShowFooter ="True" GridLines="None" Width="572px"
            >

                        <EditRowStyle BackColor="#2461BF" />

                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <AlternatingRowStyle BackColor="White" />

                        <Columns>

                            

                            <asp:BoundField DataField="iSex" HeaderText="性别" SortExpression="iSex">
                            <ItemStyle HorizontalAlign="Center" />
                            </asp:BoundField>
                            <asp:BoundField DataField="Number" HeaderText="人数" 
                                SortExpression="Number" ReadOnly="True">
                            <ItemStyle HorizontalAlign="Center" />
                            </asp:BoundField>

                        </Columns>

                        <RowStyle BackColor="#EFF3FB" />

                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <SortedAscendingCellStyle BackColor="#F5F7FB" />
                        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                        <SortedDescendingCellStyle BackColor="#E9EBEF" />
                        <SortedDescendingHeaderStyle BackColor="#4870BE" />

                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DevMgmntConnectionString %>" 
            
            
            SelectCommand="SELECT iSex,COUNT(*)  Number FROM [t_record]  group by (iSex)">
        </asp:SqlDataSource>
        
               
    </div>
    </asp:Content>
 
